Create all Cards on Dashboard 1

Step 1: Create A District Name

                 a. Fields = .District Name Measure (remove period from front in name)

                 b. Select formatting (paint roller), in general X position = 743, Y position = 0, Width = 292, Height = 68

                 c. Data Label Color = white, text size = 20, font = Constantia

                 d. Background Color = Custom (4A588A)





Step 2: Create Last Refreshed Card 

                 a. Fields = .Last Refreshed Local (remove period from front in name)

                 b. Select formatting, in general X position = 0, Y position = 76, Width = 151, Height = 69

                 c. Data Label, Color = black, text size = 10, font = Constantia

                 d. Category, Color = black, text size = 9, font = Constantia






Step 3: Create Violent Crime Rate Card

                 a. Fields = .Violent Crime Rate (remove period from front in name)

                 b. Select formatting, in general X position = 9, Y position = 270, Width = 139, Height = 81

                 c. Data Label, Color = Custom(1E5A8E), text size = 20, font = Constantia





                 

                 d. Category, Color = black, text size = 10, font = Constantia

                 e. Background = Light gray

                 f. Border = dark gray

                 g. Change Violent Crime Rate to a percentage.





Step 4: Create VCR YOY Card

                 a. Fields = .Diffs VCR YOY (change name to VCR YOY)

                 b. Select formatting, in general X position = 9, Y postion = 373, Width = 139, Height = 81




                 


                 c. Data Label, Color = color scale format, field Violent Crime Rate YOY%, Minimum = Custom, Custom Color = 00800, Value = .000001, Maximum = Custom, Custom Color = FF0000, Value = 0, text size = 20, font = Constantia





                 d. Category, Color = black, text size = 10, font = Constantia

                 e. Background = light gray





Step 5: Create Major Crime Rate Card

                 a. Copy (Ctrl + C) and paste (Ctrl + V) the Violent Crime Rate Card

                 b. Change field to .Major Crime Rate (remove period in name)

                 c. Select formatting, in general X position = 9, Y position = 475, Width = 139, Height = 81

                 d. Data label, Color = Custom (BD890F)

                 e. Make sure it is formatted to a percentage





Step 6: Create MCR YOY

                 a. Fields = .Diffs MCR YOY (rename to MCR YOY)

                 b. Select formatting, in general X position = 9, Y position = 579, Width = 139, Height = 81

                 c. Data Label, change field value to Major Crime Rate YOY in conditional format





Step 7: Create Year Slicer

                a. Field = Occurred Date /  Year

                b. Switch from a slider to a drop down

                c. Select formatting, in general X position = 9, Y position = 166, Width = 139, Height = 81

                d. Selection controls, Ctrl select off, Select all on

                e. Slicer header, Color = black, text size = 11, font = Constantia

                 f. Background = light gray

                g. Border = dark gray







Check out this article on Crime in the United States for a better understanding.


Crime in the US Link